﻿CREATE TABLE [dbo].[DebtRecurring] (
    [ID_DebtRecurring] INT           IDENTITY (1, 1) NOT NULL,
    [Id_Suplier]       INT           NOT NULL,
    [DocumentNumber]   VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Description]      VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [Id_RecurringType] INT           NOT NULL,
    [StartDate]        SMALLDATETIME NOT NULL,
    [FinalDate]        SMALLDATETIME NULL,
    [Id_CostCenter]    INT           NULL,
    [Id_Account]       INT           NOT NULL,
    [Amount]           MONEY         NULL
);

